DECLARE @Table NVARCHAR(50)  
DECLARE tmpCur CURSOR FOR   
SELECT name FROM sys.objects WHERE TYPE='U' AND name LIKE N't_%'  
OPEN tmpCur   
FETCH NEXT FROM tmpCur INTO @Table  
  
WHILE @@FETCH_STATUS = 0   
BEGIN  
    DECLARE @sql VARCHAR(100)  
    SELECT @sql = 'drop table ' + @Table  
    print @sql;
    EXEC(@sql)  
    FETCH NEXT FROM tmpCur INTO @Table  
END  
CLOSE tmpCur   
DEALLOCATE tmpCur  